package com.ilink.groundservice.mapper.culture;

import com.ilink.groundservice.entity.PO.culture.Artwork;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
* @author LENOVO
* @description 针对表【artworks】的数据库操作Mapper
* @createDate 2024-11-05 10:42:34
* @Entity generator.domain.Artworks
*/
@Mapper
public interface ArtworkMapper extends BaseMapper<Artwork> {
    @Select("SELECT tag FROM artwork " +
        "GROUP BY tag " +
        "ORDER BY COUNT(*) DESC " +
        "LIMIT #{num}")
    List<String> getCommonTags(int num);
}




